<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--
Design by Free CSS Templates
http://www.freecsstemplates.org
Released for free under a Creative Commons Attribution 2.5 License

Name       : Throughout 
Description: A two-column, fixed-width design for 1024x768 screen resolutions.
Version    : 1.0
Released   : 20100423

-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Excel RangeFinder</title>
<meta name="keywords" content="excel range finder, RangeFinder, Microsoft Excel, worksheet, Win32 API, Win32, VBA, Excel Addin, add-in, addin, Google Code, visualisation, visualization, information visualisation, information visualization, InfoVis, data visualisation, data visualization, overview plus detail, overview + detail, overview" />
<meta name="description" content="The Excel RangeFinder lets you simultaneously pan and scroll Excel worksheets without the usual cumbersome horizontal and vertical scrolling" />
<link href="style.css" rel="stylesheet" type="text/css" media="screen" />
<style type="text/css">
@import "slidertron.css";
</style>
<LINK REL="SHORTCUT ICON" HREF="http://www.grvisualisation.50webs.com/favicon.ico"> 
</head>

<div style="background-color:white;">
    <!-- Place this tag where you want the +1 button to render. -->
    <div class="g-plusone" data-annotation="inline" data-width="300"></div>
    
    <!-- Place this tag after the last +1 button tag. -->
    <script type="text/javascript">
      (function() {
        var po = document.createElement('script'); po.type = 'text/javascript'; po.async = true;
        po.src = 'https://apis.google.com/js/platform.js';
        var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(po, s);
      })();
    </script>
</div>

<body>
<!-- Google Analytics -->
<script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(['_setAccount', 'UA-5253719-2']);
  _gaq.push(['_trackPageview']);

  (function() {
    var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
    ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
    var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>
<!-- end #header-wrapper -->
<div id="logo">
	<h1>Excel RangeFinder </h1>
	<em> &nbsp;by Dr Greg Ross</em>
</div>
<div id="header">
	<div id="menu">
		<ul>
			<li><a href="http://www.grvisualisation.50webs.com/" class="first">Home</a></li>
			<li><a href="infovis.html">InfoVis</a></li>
			<li><a href="examples.html">Magic Table</a></li>
			<li><a href="javascript_voronoi.html">Voronoi</a></li>
			<li><a href="javascript_surface_plot.html">3D Surface Plot</a></li>
			<li><a href="visi_scroll.html">visi-scroll</a></li>
			<li><a href="contact.html">Contact</a></li>
		</ul>
	</div>
	<!-- end #menu -->
	<div id="search">
		<form method="get" action="http://www.google.com/search">
			<fieldset>
				<input type="text" name="q" id="search-text" size="15" />
				<input style="display:none;" type="checkbox"  name="sitesearch" value="grvisualisation.50webs.com" checked />
			</fieldset>
		</form>
	</div>
	<!-- end #search -->
</div>
<!-- end #header -->
<hr />
<!-- end #logo -->

<div id="page">
	
	<div style="text-align:left; clear:both;" width=100%>
			<img src="images/rangeFinder/Controls-thumb.PNG" alt="The RangeFinder view on a very large worksheet." />
			&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
			<img src="images/rangeFinder/options-thumb.PNG" alt="RangeFinder's display options." />
			&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
			<img src="images/rangeFinder/RangeFinder-thumb.PNG" alt="A demonstration of RangeFinder." />
		</div>
		<br>
	
	<div id="page-bgtop">
		<div id="content">
			<!-- adsense container -->
			<div>
				<div class="post" style="float: left; width:40%;">
					<h2 class="title">RangeFinder</h2>
					<div class="entry">
						<p>
							The Excel RangeFinder lets you simultaneously pan and scroll Excel worksheets 
							without the usual cumbersome horizontal and vertical scrolling. RangeFinder also
							provides a miniturised overview of the entire worksheet to provide landmarks and visual
							features to afford instant and easy navigation. Hosted on Google Code, you can download and modify the source 
						code and use or modify it as you please.
						</p>
					</div>
				</div>
				
				<div style="float: right;">
					<!--adsense code-->
					<script type="text/javascript"><!--
					google_ad_client = "pub-5899093360211244";
					/* 336x280, created 5/19/10 */
					google_ad_slot = "8698410079";
					google_ad_width = 336;
					google_ad_height = 280;
					//-->
					</script>
					<script type="text/javascript"
					src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
					</script>
					<!--end-->
				</div>
				
				<div style="clear: both;"></div>
			</div>
			<br><br>
			<!-- end adsense container -->
			
			<div class="post">
				<h2 class="title">Microsoft Excel RangeFinder </h2>
				<div class="entry">
						RangeFinder is an Excel add-in for easing navigation within large Excel 
						worksheets that contain lots of data. All of the data ranges are represented 
						as coloured blocks in the RangeFinder window and all are simultaneously visible. 
						One can immediately navigate to any range simply by selecting it in the 
						RangeFinder window. The current Excel view port is represented on the window 
						and can be dragged to quickly pan and scroll the Excel view thus circumventing 
						the need for tiresome horizontal and vertical scrolling.
						
						<div style="text-align:center;">
							<img src="images/rangeFinder/RangeFinder.PNG" width="350" height="300" alt="" /><br>
						</div>
						<p class="figureCaption">
						A demonstration of RangeFinder.
						</p>
						<br><br><br>
						
						<div style="text-align:center;">
							<img src="images/rangeFinder/Controls.PNG" alt="" /><br>
						</div>
						<p class="figureCaption">
						The RangeFinder view on a very large worksheet. The options become visible upon hovering the
						mouse over the bottom of the view.
						</p>
						<br><br><br>
						
						<div style="text-align:center;">
							<img src="images/rangeFinder/options.PNG" alt="" /><br>
						</div> 
						<p class="figureCaption">
						RangeFinder's display options.
						</p>
						<br><br><br>
						
						<br>
						<br>
						<span class="bold">RangeFinder has been tested on Excel 2002 and 2003.</span>

				</div>
				
			</div>
			<div class="post">
				<h2 class="title">Installation </h2>
				<div class="entry">
						To install, copy the downloaded XLA file to 
						<span class="italicBlue">C:\Documents and Settings\&lt;your username&gt;\Application Data\Microsoft\Addins</span>. 
						Then, open Excel, select the <span class="bold">"Tools"</span> menu followed by the <span class="bold">"Add-ins..."</span> 
						option. When the Add-ins dialogue is displayed, press the "Browse" button 
						and select the <span class="bold">RangeFinder.xla</span> file. This will place a <span class="bold">"Visualisation"</span> menu 
						in Excel that can be selected to open the add-in. 

				</div>
				
			</div>
			
			<div class="post">
				<h2 class="title">Resources </h2>
				<div class="entry">
					<a href="http://www.vertex42.com/ExcelLinks/">Excel Add-ins, Templates and Resources</a> 
					- Find hundreds of Excel resources in Vertex42's Excel Nexus - The Ultimate Directory of Excel links. 
				</div>
				
			</div>
		</div>
		<!-- end #content -->
		<div id="sidebar">
			<ul>
				<li>
					<h2>Features </h2>
					<ul>
						<li class="feature">excel worksheet overview</li>
						<li class="feature">overview + detail visualisation</li>
						<li class="feature">simultaneous pan and scroll</li>
						<li class="feature">instant navigation</li>
						<li class="feature">utilises Win32 API</li>
					</ul>
				</li>
				<li>
					<h2>License </h2>
					<ul>
						<li><a href="http://www.gnu.org/licenses/gpl.html">GNU General Public License v3</a></li>
					</ul>
				</li>
				<li>
					<h2>Downloads and source</h2>
					<div><a href="http://code.google.com/p/excel-range-finder/downloads/detail?name=RangeFinder.xla" class="links">Download</a></div>
					<div><a href="http://code.google.com/p/excel-range-finder/source/checkout" class="links">SVN checkout</a></div>
					<p>
						I spent a lot of time and effort building the Excel Range Finder and it's totally free. It's thirsty work, so if you like it then 
						I'd appreciate it if you...
					</p>
					<div style="text-align:center;">
						<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
							<input type="hidden" name="cmd" value="_s-xclick">
							<input type="hidden" name="hosted_button_id" value="JZSZZTB8LXNBG">
							<input type="image" src="http://www.grvisualisation.50webs.com/images/bmab.png" border="0" name="submit" alt="PayPal - The safer, easier way to pay online.">
							<img alt="" border="0" src="https://www.paypal.com/en_GB/i/scr/pixel.gif" width="1" height="1">
						</form>
					</div>
				</li>
				<li>
					<h2>iPhone Apps </h2>
					<ul>
						<li class="feature"><a href="http://caligramsoftware.co.uk/peekaboo">Peekaboo 3D</a></li>
						<li class="feature"><a href="http://caligramsoftware.co.uk">ClapTrax</a></li>
					</ul>
				</li>
			</ul>
		</div>
		<!-- end #sidebar -->
		<div style="clear: both;">&nbsp;</div>
	</div>
	<!-- end #page -->
</div>
<div id="footer">
	<p>Copyright (c) 2008 Dr Greg Ross. All rights reserved. Design by <a href="http://www.freecsstemplates.org/">Free CSS Templates</a>.</p>
</div>
<!-- end #footer -->
</body>
</html>
